Unable to access MySQL from MyPHPAdmin after setting root password in EasyPHP{WAMP}

Posted by Codex on Stack Overflow See other posts from Stack Overflow or by Codex
Published on 2010-03-29T19:49:45Z Indexed on 2010/03/30 1:33 UTC
Read the original article Hit count: 982

Filed under:
|
|
|
|

Am a new starter with WAMP and trying to play around my way using the EasyPHP setup. After successful setup on intial launch of MySQL, the page prompted me to set up ROOT password for security reasons.

On setting the password, am no longer able to access MySQL. The error is :

Error

MySQL said: Documentation
1045 - Access denied for user 'root'@'localhost' (using password: NO) 

Looked up on the net and tried the following options in the config.inc.php from the phpmyadmin foler:

1] Set the authetication to "http" so that it prompts to enter the username and password

/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'http';

2] Set up the correct password in the config file

$cfg['Servers'][$i]['password'] = 'myPwd';

None of them worked.

Can anyone suggest a workaround to access MySQL? Am not fussed about not being able to use the root account but would like to CRUD on the database using other username.

Thanks in advance.

© Stack Overflow or respective owner

Related posts about easyphp

Related posts about mysql